Statistics for Maintenance Modelling: Continuous Lifetime Distributions 2

# Calculating the Gamma Distribution Using Excel¤

The Excel function:

GAMMADIST(x, alpha, beta, cumulative)

calculates the probability density function or the cumulative distribution for the gamma. The parameters of this Excel function are:

- x corresponds to t in our notation
- alpha corresponds to N in our notation
- beta corresponds to 1/ in our notation
- cumulative is false if it's the probability density function that you require and true if it's the cumulative distribution function that you want instead.

The inverse of the cumulative distribution function is given by the Excel function:

GAMMAINV(probability, alpha, beta)

Close